SELECT 
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow=[0]>
      [A<MiscTag>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[A<MiscTag>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow=[0]>
      [<ROwner>].[<RTable>].[<RDisplayField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsCurRow<>[0]>
     ,[<ROwner>].[<RTable>].[<RDisplayField>]
     <IsNotRelated>
     <And>
     <IsCurRow=[0]>
      [<Owner>].[<Table>].[<Field>]
     <IsNotRelated>
     <And>
     <IsCurRow<>[0]>
     ,[<Owner>].[<Table>].[<Field>]
</If Loop>
FROM
     [<Owner>].[<Table>]
<If Loop>
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNull>
     LEFT JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
     <IsRelated>
     <And>
     <IsMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] as [A<MiscTag>] ON [<Owner>].[<Table>].[<Field>] = [A<MiscTag>].[<RField>]
     <IsRelated>
     <And>
     <IsNotMiscTag>
     <And>
     <IsNotNull>
     INNER JOIN [<ROwner>].[<RTable>] ON [<Owner>].[<Table>].[<Field>] = [<ROwner>].[<RTable>].[<RField>]
</If Loop>
WHERE
<If Loop>
   If <Comment> 
      <IsPKey>
      <And>
      <IsNumber>
   Then <Comment>
 <SF[AND ]>[<Field>] = <>
   ElseIf <Comment> 
      <IsPKey>
      <And>
      <IsNotNumber>
   Then <Comment>
 <SF[AND ]>[<Field>] = '<>'
   End If <Comment> 
</If Loop>
<If Loop>
   If <Comment>
      <IsNotPKey>
      <And>
      <IsIdentity>
      <And>
      <IsNumber>
   Then <Comment>
     [<Field>] = <>
   ElseIf <Comment>
      <IsNotPKey>
      <And>
      <IsIdentity>
      <And>
      <IsNotNumber>
   Then <Comment>
     [<Field>] = '<>'
   End If<Comment>
</If Loop>
<If Loop>
   If <Comment>
      <IsNotIdentityCount>
      <And>
      <IsNotPKeyCount>
      <And>
      <IsNotText>
      <And>
      <IsNotNText>
      <And>
      <IsNotXML>
      <And>
      <IsNumber>
   Then <Comment>
     [<Field>] = <>
     <ExitLoop>
   ElseIf <Comment>
      <IsNotIdentityCount>
      <And>
      <IsNotPKeyCount>
      <And>
      <IsNotText>
      <And>
      <IsNotNText>
      <And>
      <IsNotXML>
      <And>
      <IsNotNumber>
   Then <Comment>
     [<Field>] = '<>'
     <ExitLoop>
   End If <Comment>
</If Loop>

